Linkedin

Author

Dataclin

Published

October 17, 2024

1 1. Intoduction

1.0.0.1 We have 12 datasets, 4 categories (DataClin, CRO, MA, and SMO), Each category has 3 datasets (Visitors, Followers, Content)

    1. Visitors’ datasets provide insights about people who visit any of DataClin LinkedIn pages in a detailed way as follows
      • number of people visited the page using mobile/ desktop and total of them

      • number of people visited the life/ Jobs pages 

      • unique number of visitors (may differ from the total number as this column removes duplicate visitors)

      • There are 5 sheets in the dataset, each sheet aggregates the data according to a different variable of the below:

        • Location

        • Seniority (titles of people who visited the pages)

        • Job functions

        • Industry

        • Company size

    1. Followers’ datasets provide insights about followers of any DataClin LinkedIn pages in a detailed way as follows
      • number of organic followers (followers of genuine interest without any paid promotions)

      • number of sponsored followers (though ads) 

      • auto-invitations (Premium feature that sends invitation automatically to LinkedIn users to follow DataClin pages)

      • There are 5 sheets in the dataset, each sheet aggregates the data according to a different variable of the below:

        • Location

        • Seniority (titles of people who visited the pages)

        • Job functions

        • Industry

        • Company size

    1. Content’s datasets provide insights about the content of any DataClin LinkedIn pages in a detailed way as follows
      • number of impressions (how many times the post has been shown to people on LinkedIn), clicks (how many unique clicks on the post), reactions, comments, reposts, and engagement rates (which = total number of interactions + Clicks + followers/ number of impressions)

      • the sheet called “All posts” collects posts shared on LinkedIn with their dates, who posted them, impressions, views, clicks, interactions, and engagement rate

      • the click through rate (CTR): (number of clicks/ number of impressions) – The rate of people who see the posts and click on them

2 2. Questions

    1. Is there a statistically significant trend for each page when comparing month-over-month data in:
      • total impressions

      • Total unique impressions

      • Total clicks

      • Total reactions

      • Total comments

      • Total reposts

      • Total engagement rate

    2. Which page has the best total unique impressions overall?
    3. Which page has the best average unique impressions overall?
    4. Are there any specific metrics where one employee consistently achieves higher counts than the other?

3 3. Exploratory Data Analysis

  • Q1: Is there a statistically significant trend for each page when comparing month-over-month data in:

    • total impressions

    • Total unique impressions

    • Total clicks

    • Total reactions

    • Total comments

    • Total reposts

    • Total engagement rate

  • Q2 :Which page has the best total unique impressions overall?

  • Q3: Which page has the best average unique impressions overall?

  • Q4: Are there any specific metrics where one employee consistently achieves higher counts than the other?

3.0.0.1 Employee performance overall posts

3.0.0.2 Employee performance Top 10 posts

4 5. Conclusions

5 6. Recommendations

6 7. Limitations